DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

dbmysqlvbapi.zip

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

Shrinking DB

Steps to shrink database in MS SQL

DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

ImagesIn_Count

Counts number of image files found in a folder Images defined here are files ...

ChrW

Insert special characters inside Cell, using ChrW

GenerateRandom

Generates a random string, returns string passed, then full date, then 8-chars ...

RmDir

Delete a folder, expects to be an empty folder, path must be already MapPathed

Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...